set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

msck repair table  jms_ods.yl_lmdm_sys_customer_addition;
insert overwrite table jms_dim.dim_lmdm_sys_customer_addition
select
   id
  ,code
  ,name
  ,create_by
  ,update_by
  ,create_by_name
  ,update_by_name
  ,create_time
  ,update_time
  ,is_enable
  ,is_delete
  ,relation_code
  ,label string
  ,main_engine_platform
  ,customer_level
  ,is_brand_owner
  ,brand_owner_name
  ,customer_category
  ,customer_label
  ,audit_status
  ,share_network_ids
from jms_ods.yl_lmdm_sys_customer_addition where dt= '{{ execution_date | cst_ds }}';